Data Prep 2: Cuddly Stuffed Animals Append

Price: $ 14.99



This case scenario involves sales of cuddly stuffed animals. It can be used in general business or accounting courses. Students extract a sheet from an Excel workbook. They first transform the data as explained in the single stream. The second stream is then extracted from the Excel workbook. Then in addition to the steps used to clean the first stream they separate a combined field into two separate fields, rename fields to match the names used in the first stream, change the filed types to match the field types in the first stream, create new fields append the two streams and export the modified file. Then the students load the file back into the Excel file and answer analytical questions related to their unique data. The case can be solved using Alteryx, Power BI or Tableau and a free mini tutorial and data set is available.

Table of contents

View chapter in pdf form

View chapter in ppt form

The book comes with a quizzing system, with each student being presented with a timed quiz comprising five questions selected at random from the database of quiz questions for the chapter. Instructors can assign these quizzes in advance of the topics to be covered in class, giving students an incentive to read the chapter in advance of the class. Students read the chapters and take the online quizzes prior to class.

Each chapter features hyperlinks to related information, taking advantage of the online nature of the book. Additionally, the chapters featuring Microsoft Access databases permit the databases to be downloaded by students for further exploration.

The following are some of the resources available for adopting instructors:

  • Solutions to end-of-chapter questions and problems
  • The ability to make selected solutions available to students
  • The ability to view all quiz questions for a chapter
  • The ability to generate quiz grade reports
  • Sample tests
  • Powerpoint files for each chapter

Videos Demo

Other products


E-Books

No Image Available.
No Image Available.
No Image Available.

Analytics Products

No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.

Excel Accounting Practice Sets

No Image Available.
No Image Available.
No Image Available.
No Image Available.